package com.xdcplus.web.mapper;

import com.xdcplus.mp.mapper.IBaseMapper;
import com.xdcplus.web.common.pojo.entity.OpeJobTaskStaffing;
import com.xdcplus.web.common.pojo.query.OpeJobTaskStaffingQuery;
import com.xdcplus.web.common.pojo.vo.OpeJobTaskStaffingVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * (OpeJobTaskStaffing)表数据库访问层
 *
 * @author Zhecheng.Ren
 * @since 2024-10-29 14:59:20
 */
public interface OpeJobTaskStaffingMapper extends IBaseMapper<OpeJobTaskStaffing> {

    /**
     * 查询(OpeJobTaskStaffing)
     *
     * @param opeJobTaskStaffingQuery (OpeJobTaskStaffing)查询
     * @return {@link List<OpeJobTaskStaffing>}
     */
    List<OpeJobTaskStaffingVO> queryOpeJobTaskStaffing(OpeJobTaskStaffingQuery opeJobTaskStaffingQuery);

    OpeJobTaskStaffing queryByToolCodeAndShift(@Param("toolCode") String toolCode, @Param("shiftCode") String shiftCode);

    OpeJobTaskStaffing queryByToolCodeAndShiftNotId(@Param("toolCode") String toolCode, @Param("shiftCode") String shiftCode, @Param("id") Long id);

    void deleteByToolCodeAndShiftCode(@Param("toolCode") String toolCode, @Param("shiftCode") String shiftCode);

}
